﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace Bepo.Model.Setup.Tasks
{
	public class _20120607_CreateBusinessModelTable : DatabaseSetupTask
	{
		public override DateTime DevelopedOn
		{
			get { return new DateTime(2012, 6, 7); }
		}

		public override string Script
		{
			get {
				return @"
					if (object_id('BusinessModel') is null) begin
						Create table dbo.BusinessModel
                        (
							[Id] [uniqueidentifier] NOT NULL,
							[Name] [nvarchar](255) NOT NULL,
							[Description] [nvarchar](1000),
							[CreatedOn] [smalldatetime] NOT NULL,
							[SerializedProperties] [nvarchar](max),
							CONSTRAINT [PK_BusinessModel] PRIMARY KEY CLUSTERED 
							(
								[Id] ASC
							)
                        )
					end";
			
			}
		}
	}
}
